/*
 Navicat Premium Data Transfer

 Source Server         : 本机
 Source Server Type    : MySQL
 Source Server Version : 100137
 Source Host           : 127.0.0.1:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 100137
 File Encoding         : 65001

 Date: 15/04/2020 18:47:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` varchar(32) NOT NULL COMMENT '角色id',
  `permission_id` varchar(32) NOT NULL COMMENT '权限id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of role_permission
-- ----------------------------
BEGIN;
INSERT INTO `role_permission` VALUES (1, '1', '1');
INSERT INTO `role_permission` VALUES (2, '1', '2');
INSERT INTO `role_permission` VALUES (3, '1', '3');
INSERT INTO `role_permission` VALUES (4, '1', '13e8917acab746dabef910b9b69a9a70');
INSERT INTO `role_permission` VALUES (5, '1', '41e809adf4c14c528fc3b581096739ff');
COMMIT;

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `id` varchar(32) NOT NULL,
  `name` varchar(100) NOT NULL COMMENT '权限名称',
  `description` varchar(255) DEFAULT NULL COMMENT '权限描述',
  `url` varchar(255) DEFAULT NULL COMMENT '权限访问路径',
  `perms` varchar(255) DEFAULT NULL COMMENT '权限标识',
  `parent_id` varchar(32) DEFAULT NULL COMMENT '父级权限id',
  `type` int(1) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `order_num` int(3) DEFAULT '0' COMMENT '排序',
  `icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `resource_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
BEGIN;
INSERT INTO `sys_permission` VALUES ('0', '根目录', '菜单根目录', '#', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `sys_permission` VALUES ('00721ff49e7646779754dcb40e7fd9e9', '系统管理', NULL, '/platform/systime/list', 'platform:systime', '13e8917acab746dabef910b9b69a9a70', 1, 0, NULL, NULL, NULL, 'menu');
INSERT INTO `sys_permission` VALUES ('1', '基础管理', '管理用户信息权限配置', '#', 'sys:user', '0', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `sys_permission` VALUES ('13e8917acab746dabef910b9b69a9a70', '平台管理', NULL, '#', 'platform:init', '0', 1, 0, NULL, NULL, NULL, 'menu');
INSERT INTO `sys_permission` VALUES ('2', '用户管理', '管理用户信息', '/sys/user/list', 'sys:userInfo', '1', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `sys_permission` VALUES ('3', '菜单管理', '管理菜单', '/permission/list', 'sys:permission', '1', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `sys_permission` VALUES ('41ccbaa7ab70424f834aab9bf18c565c', '角色管理', NULL, '/sys/role/list', 'sys:role', '1', 1, 0, NULL, NULL, NULL, 'menu');
COMMIT;

-- ----------------------------
-- Table structure for sys_platform
-- ----------------------------
DROP TABLE IF EXISTS `sys_platform`;
CREATE TABLE `sys_platform` (
  `id` varchar(32) NOT NULL,
  `name` varchar(40) DEFAULT NULL COMMENT '系统名称',
  `url` varchar(90) DEFAULT NULL COMMENT '请求地址',
  `img` varchar(90) DEFAULT NULL COMMENT '图片',
  `color` varchar(255) DEFAULT NULL COMMENT '颜色',
  `create_user` varchar(40) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_user` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_platform
-- ----------------------------
BEGIN;
INSERT INTO `sys_platform` VALUES ('1', '系统设置管理', '/system/index', 'http://demo.shecuntong.cn:6705/Content/DCenter/images/uicon/u_dsjzx.png', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_platform` VALUES ('98f21cd7cfbf4ec6ba5cd486d1e26bf2', '百度', 'www.baidu.com', 'https://www.baidu.com/img/baidu_jgylogo3.gif', NULL, '1', '2020-04-15 04:48:38', '1', '2020-04-15 04:48:38');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` varchar(32) NOT NULL,
  `name` varchar(50) NOT NULL COMMENT '角色名称',
  `description` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `status` int(1) NOT NULL COMMENT '状态：1有效；2删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', '超级管理员', '最大用户管理者', 1, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` varchar(32) NOT NULL,
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `pass_word` varchar(50) DEFAULT NULL,
  `salt` varchar(128) DEFAULT NULL COMMENT '加密盐值',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(50) DEFAULT NULL COMMENT '联系方式',
  `sex` int(255) DEFAULT NULL COMMENT '年龄：1男2女',
  `age` int(3) DEFAULT NULL COMMENT '年龄',
  `status` int(1) NOT NULL COMMENT '用户状态：1有效; 2删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `name` varchar(255) DEFAULT NULL COMMENT '用户名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` VALUES ('1', 'admin', '928bfd2577490322a6e19b793691467e', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES ('145e954b6c8940cfb79fa40e977a8ffa', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:08:58', NULL, NULL);
INSERT INTO `user_info` VALUES ('2637257745a34dd09ef4fb555bce6acb', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:08:13', NULL, NULL);
INSERT INTO `user_info` VALUES ('3a93e9c417bb413e961e7168aa365c8f', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:08:19', NULL, NULL);
INSERT INTO `user_info` VALUES ('48349f5736704ae695b2762bc9372cb4', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:09:03', NULL, NULL);
INSERT INTO `user_info` VALUES ('4c0e23054e4547ccb7a43165ee368dfb', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:07:21', NULL, NULL);
INSERT INTO `user_info` VALUES ('4c53157ba8094d668a76ea590a02c453', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:09:01', NULL, NULL);
INSERT INTO `user_info` VALUES ('4ea311ec67b94243bd50bd458f390610', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:07:35', NULL, NULL);
INSERT INTO `user_info` VALUES ('55a09acd7d8a4cf58fbb9a31bfce92e5', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:07:11', NULL, NULL);
INSERT INTO `user_info` VALUES ('5998c251d02d46c89efae6e33053012b', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-12 21:39:53', NULL, NULL);
INSERT INTO `user_info` VALUES ('5de0f51bf8844bcfadcdf06ebcceeee2', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:09:53', NULL, NULL);
INSERT INTO `user_info` VALUES ('6684f685f1664184ae664b306a6769a2', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:07:03', NULL, NULL);
INSERT INTO `user_info` VALUES ('862745ea9c10426fb307626f376e60af', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:09:58', NULL, NULL);
INSERT INTO `user_info` VALUES ('89a141b87c564704b30cd8e77a3eeff6', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:08:51', NULL, NULL);
INSERT INTO `user_info` VALUES ('8a6833b9a78d42edb31604ac41d2e1dd', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:09:56', NULL, NULL);
INSERT INTO `user_info` VALUES ('9e2ff5e867d24e178c85f92680b6e6d1', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:07:31', NULL, NULL);
INSERT INTO `user_info` VALUES ('b27287be488d4a64becdddb21b743c58', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:10:00', NULL, NULL);
INSERT INTO `user_info` VALUES ('b9318acc8c2a49fa887c765cb5bc0bc5', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:10:04', NULL, NULL);
INSERT INTO `user_info` VALUES ('bc9342dba409444a9bcff36e1c24b338', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:10:02', NULL, NULL);
INSERT INTO `user_info` VALUES ('bc93a556850b40509c8ba550dc6a1e07', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:07:58', NULL, NULL);
INSERT INTO `user_info` VALUES ('cb618e72c78c4ddd8f45908816e4d508', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:07:15', NULL, NULL);
INSERT INTO `user_info` VALUES ('fb081d530eb342f3b8777921ec4da692', NULL, NULL, NULL, '742198177@qq.com', '13636779189', NULL, NULL, 0, NULL, '2020-04-10 05:07:17', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user_platform
-- ----------------------------
DROP TABLE IF EXISTS `user_platform`;
CREATE TABLE `user_platform` (
  `id` varchar(32) NOT NULL,
  `user_id` varchar(32) DEFAULT NULL,
  `platform_id` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_platform
-- ----------------------------
BEGIN;
INSERT INTO `user_platform` VALUES ('1', '1', '1');
INSERT INTO `user_platform` VALUES ('2', '1', '98f21cd7cfbf4ec6ba5cd486d1e26bf2');
COMMIT;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) NOT NULL COMMENT '用户id',
  `role_id` varchar(20) NOT NULL COMMENT '角色id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_role
-- ----------------------------
BEGIN;
INSERT INTO `user_role` VALUES (1, '1', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
